SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Lincoln, NE') ORDER BY last_name ASC, first_name, date, patent, type |
Total of 5 patents found where: Residence is 'Lincoln, NE';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
T / S | Patent | Date | Description | Patentee | Category | Assigned To |
SNAPP, Delos V. FRAHER, Charles W. | ||||||
U | 877,242 | January 21, 1908 | Insulator Pin Pin with metal shank and bolt |
SNAPP, Delos V. FRAHER, Charles W. |
Pin | |
HOSFIELD, Glenn E. | ||||||
U | 2,215,152 | September 17, 1940 | Insulator Rubber insert |
HOSFIELD, Glenn E. |
Rubber | |
SHINN, William C. | ||||||
U | 887,277 | May 12, 1908 | Machine for Making Cable Lightning Rods Machine for making cable conductors that is a cable within a cable for greatest flexibility and conduction |
SHINN, William C. |
Lightning Rod Machine | |
U | 995,638 | June 20, 1911 | Brace for Lightning Rod Tops Lightning rod tripod to support rod with ball ornament |
SHINN, William C. |
Lightning Rod | |
ZIEG, Joseph | ||||||
U | 1,147,065 | July 20, 1915 | Insulator Clamp and Bracket Steel bracket and pin combination that fits around the crossarm |
ZIEG, Joseph |
Bracket |
Total of 0.01 seconds